Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	34642
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.3 MiB
Average record size in memory	160.0 B

Variable types

Numeric	19
DateTime	1

Alerts

`AC 17` is highly correlated with `AC 18`	High correlation
`AC 18` is highly correlated with `AC 17`	High correlation
`df_index` is highly correlated with `AC 1` and 3 other fields	High correlation
`AC 1` is highly correlated with `df_index`	High correlation
`AC 2` is highly correlated with `df_index` and 1 other fields	High correlation
`AC 3` is highly correlated with `df_index`	High correlation
`AC 4` is highly correlated with `AC 2`	High correlation
`AC 11` is highly correlated with `AC 12` and 1 other fields	High correlation
`AC 12` is highly correlated with `AC 11`	High correlation
`AC 14` is highly correlated with `AC 11`	High correlation
`AC 17` is highly correlated with `AC 18`	High correlation
`AC 18` is highly correlated with `df_index` and 1 other fields	High correlation
`df_index` has unique values	Unique
`Date & Time` has unique values	Unique
`AC 1` has 11570 (33.4%) zeros	Zeros
`AC 2` has 3613 (10.4%) zeros	Zeros
`AC 3` has 3809 (11.0%) zeros	Zeros
`AC 4` has 7581 (21.9%) zeros	Zeros
`AC 5` has 2588 (7.5%) zeros	Zeros
`AC 6` has 5455 (15.7%) zeros	Zeros
`AC 7` has 3355 (9.7%) zeros	Zeros
`AC 8` has 5331 (15.4%) zeros	Zeros
`AC 9` has 2367 (6.8%) zeros	Zeros
`AC 10` has 1903 (5.5%) zeros	Zeros
`AC 11` has 5270 (15.2%) zeros	Zeros
`AC 12` has 3163 (9.1%) zeros	Zeros
`AC 13` has 1852 (5.3%) zeros	Zeros
`AC 14` has 1423 (4.1%) zeros	Zeros
`AC 15` has 2994 (8.6%) zeros	Zeros
`AC 16` has 3661 (10.6%) zeros	Zeros
`AC 17` has 583 (1.7%) zeros	Zeros
`AC 18` has 837 (2.4%) zeros	Zeros

Reproduction

Analysis started	2021-12-22 19:55:28.558002
Analysis finished	2021-12-22 19:56:38.477648
Duration	1 minute and 9.92 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	34642
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47474.87836

Minimum	0
Maximum	87839
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3536.1
Q1	17874.5
median	51180
Q3	70077.5
95-th percentile	84296.9
Maximum	87839
Range	87839
Interquartile range (IQR)	52203

Descriptive statistics

Standard deviation	26576.43508
Coefficient of variation (CV)	0.5597999615
Kurtosis	-1.148025165
Mean	47474.87836
Median Absolute Deviation (MAD)	19907
Skewness	-0.3319867658
Sum	1644624736
Variance	706306901.4
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
41761	1	< 0.1%
70336	1	< 0.1%
72162	1	< 0.1%
72502	1	< 0.1%
66904	1	< 0.1%
2868	1	< 0.1%
15154	1	< 0.1%
74545	1	< 0.1%
11056	1	< 0.1%
Other values (34632)	34632	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
2	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
18	1	< 0.1%
20	1	< 0.1%

Value	Count	Frequency (%)
87839	1	< 0.1%
87837	1	< 0.1%
87835	1	< 0.1%
87833	1	< 0.1%
87831	1	< 0.1%
87829	1	< 0.1%
87827	1	< 0.1%
87825	1	< 0.1%
87823	1	< 0.1%
87821	1	< 0.1%

Date & Time
Date

UNIQUE

Distinct	34642
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	270.8 KiB

Minimum	2019-08-01 00:00:00
Maximum	2019-09-30 23:59:00

Histogram

Histogram with fixed size bins (bins=50)

AC 1
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	23054
Distinct (%)	66.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.394089398

Minimum	0
Maximum	11.19478906
Zeros	11570
Zeros (%)	33.4%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2.081296143
Q3	3.767716064
95-th percentile	6.897859058
Maximum	11.19478906
Range	11.19478906
Interquartile range (IQR)	3.767716064

Descriptive statistics

Standard deviation	2.309156098
Coefficient of variation (CV)	0.9645237559
Kurtosis	-0.03893428644
Mean	2.394089398
Median Absolute Deviation (MAD)	2.081296143
Skewness	0.7917478274
Sum	82936.04491
Variance	5.332201884
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11570	33.4%
3.019473633	2	< 0.1%
1.871588867	2	< 0.1%
7.455938965	2	< 0.1%
4.186901855	2	< 0.1%
4.132759766	2	< 0.1%
2.908268066	2	< 0.1%
3.164794434	2	< 0.1%
6.021251953	2	< 0.1%
4.524077637	2	< 0.1%
Other values (23044)	23054	66.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11570	33.4%
0.0616844368	1	< 0.1%
0.07653198242	1	< 0.1%
0.1067472687	1	< 0.1%
0.11033638	1	< 0.1%
0.1174385757	1	< 0.1%
0.122889595	1	< 0.1%
0.1323277283	1	< 0.1%
0.1344907684	1	< 0.1%
0.1487676697	1	< 0.1%

Value	Count	Frequency (%)
11.19478906	1	< 0.1%
11.02978223	1	< 0.1%
11.02866602	1	< 0.1%
11.0239375	1	< 0.1%
11.01845313	1	< 0.1%
11.00308691	1	< 0.1%
10.99454395	1	< 0.1%
10.96971777	1	< 0.1%
10.91394434	1	< 0.1%
10.79010742	1	< 0.1%

AC 2
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	31006
Distinct (%)	89.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.872065429

Minimum	0
Maximum	11.14714063
Zeros	3613
Zeros (%)	10.4%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.272895203
median	3.738743286
Q3	5.334570435
95-th percentile	8.27211416
Maximum	11.14714063
Range	11.14714063
Interquartile range (IQR)	3.061675232

Descriptive statistics

Standard deviation	2.360155204
Coefficient of variation (CV)	0.6095339159
Kurtosis	-0.2211130572
Mean	3.872065429
Median Absolute Deviation (MAD)	1.524687866
Skewness	0.3305838235
Sum	134136.0906
Variance	5.570332585
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3613	10.4%
2.872945557	2	< 0.1%
2.724344482	2	< 0.1%
4.035023437	2	< 0.1%
4.527638672	2	< 0.1%
4.438061523	2	< 0.1%
8.185853027	2	< 0.1%
3.283741943	2	< 0.1%
9.111301758	2	< 0.1%
3.12289502	2	< 0.1%
Other values (30996)	31011	89.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3613	10.4%
0.04285964203	1	< 0.1%
0.04794764328	1	< 0.1%
0.06230761337	1	< 0.1%
0.0639708786	1	< 0.1%
0.06400770569	1	< 0.1%
0.0640224762	1	< 0.1%
0.06408698273	1	< 0.1%
0.06414063263	1	< 0.1%
0.06518546295	1	< 0.1%

Value	Count	Frequency (%)
11.14714063	1	< 0.1%
11.1288418	1	< 0.1%
11.11222559	1	< 0.1%
11.09907031	1	< 0.1%
11.07564746	1	< 0.1%
11.0496377	1	< 0.1%
11.03469531	1	< 0.1%
11.0314541	1	< 0.1%
11.01084863	1	< 0.1%
11.00639453	1	< 0.1%

AC 3
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	30800
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.504698491

Minimum	0
Maximum	8.43090918
Zeros	3809
Zeros (%)	11.0%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.663071533
median	2.417197144
Q3	3.351790955
95-th percentile	5.04409082
Maximum	8.43090918
Range	8.43090918
Interquartile range (IQR)	1.688719421

Descriptive statistics

Standard deviation	1.452713419
Coefficient of variation (CV)	0.5799953265
Kurtosis	0.3613781141
Mean	2.504698491
Median Absolute Deviation (MAD)	0.8353283081
Skewness	0.3422027003
Sum	86767.76513
Variance	2.110376278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3809	11.0%
3.847365479	2	< 0.1%
1.365873291	2	< 0.1%
1.880836792	2	< 0.1%
2.587766113	2	< 0.1%
2.910477783	2	< 0.1%
1.578948364	2	< 0.1%
2.36289209	2	< 0.1%
2.159558105	2	< 0.1%
2.099674316	2	< 0.1%
Other values (30790)	30815	89.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3809	11.0%
0.0742535553	1	< 0.1%
0.07536616516	1	< 0.1%
0.07730276489	1	< 0.1%
0.0794705658	1	< 0.1%
0.08052623749	1	< 0.1%
0.08061908722	1	< 0.1%
0.08279086304	1	< 0.1%
0.09293652344	1	< 0.1%
0.09821147156	1	< 0.1%

Value	Count	Frequency (%)
8.43090918	1	< 0.1%
8.411494141	1	< 0.1%
8.333665039	1	< 0.1%
8.330175781	1	< 0.1%
8.272776367	1	< 0.1%
8.262228516	1	< 0.1%
8.238150391	1	< 0.1%
8.235042969	1	< 0.1%
8.225069336	1	< 0.1%
8.203635742	1	< 0.1%

AC 4
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	27035
Distinct (%)	78.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.313283362

Minimum	0
Maximum	9.849143555
Zeros	7581
Zeros (%)	21.9%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.279719116
median	2.255592773
Q3	3.313595459
95-th percentile	5.370586548
Maximum	9.849143555
Range	9.849143555
Interquartile range (IQR)	2.033876343

Descriptive statistics

Standard deviation	1.705811038
Coefficient of variation (CV)	0.737398222
Kurtosis	0.009144763889
Mean	2.313283362
Median Absolute Deviation (MAD)	1.019396179
Skewness	0.4474233639
Sum	80136.76223
Variance	2.909791298
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7581	21.9%
2.34465625	2	< 0.1%
3.024609375	2	< 0.1%
2.34965625	2	< 0.1%
4.424061035	2	< 0.1%
2.519458252	2	< 0.1%
2.785541016	2	< 0.1%
2.267689453	2	< 0.1%
2.712394775	2	< 0.1%
4.321238281	2	< 0.1%
Other values (27025)	27043	78.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7581	21.9%
1.423256192 × 10^-5	1	< 0.1%
0.0004910462797	1	< 0.1%
0.001534701347	1	< 0.1%
0.002670838594	1	< 0.1%
0.002782246113	1	< 0.1%
0.003369998693	1	< 0.1%
0.003763606787	1	< 0.1%
0.004028562069	1	< 0.1%
0.01386952305	1	< 0.1%

Value	Count	Frequency (%)
9.849143555	1	< 0.1%
9.728601562	1	< 0.1%
9.631849609	1	< 0.1%
9.600250977	1	< 0.1%
9.549112305	1	< 0.1%
9.538166016	1	< 0.1%
9.518945312	1	< 0.1%
9.518727539	1	< 0.1%
9.469880859	1	< 0.1%
9.36712793	1	< 0.1%

AC 5
Real number (ℝ_≥0)

ZEROS

Distinct	32023
Distinct (%)	92.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.466444486

Minimum	0
Maximum	5.495358398
Zeros	2588
Zeros (%)	7.5%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.00832634
median	1.408947998
Q3	1.903033508
95-th percentile	2.756116174
Maximum	5.495358398
Range	5.495358398
Interquartile range (IQR)	0.8947071686

Descriptive statistics

Standard deviation	0.7485150551
Coefficient of variation (CV)	0.510428497
Kurtosis	0.7236269949
Mean	1.466444486
Median Absolute Deviation (MAD)	0.4394423523
Skewness	0.3511872826
Sum	50800.5699
Variance	0.5602747877
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2588	7.5%
2.03893042	2	< 0.1%
1.979017456	2	< 0.1%
1.50166687	2	< 0.1%
1.77949707	2	< 0.1%
1.261974976	2	< 0.1%
1.239431274	2	< 0.1%
2.493119141	2	< 0.1%
1.071717529	2	< 0.1%
2.062584473	2	< 0.1%
Other values (32013)	32036	92.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2588	7.5%
0.07341772461	1	< 0.1%
0.07348339081	1	< 0.1%
0.07452122498	1	< 0.1%
0.07495846558	1	< 0.1%
0.07612695312	1	< 0.1%
0.08035838318	1	< 0.1%
0.09692716217	1	< 0.1%
0.1132143555	1	< 0.1%
0.1216780243	1	< 0.1%

Value	Count	Frequency (%)
5.495358398	1	< 0.1%
5.20192334	1	< 0.1%
5.043223633	1	< 0.1%
5.041179199	1	< 0.1%
4.906216797	1	< 0.1%
4.892197754	1	< 0.1%
4.884592285	1	< 0.1%
4.87679248	1	< 0.1%
4.876376465	1	< 0.1%
4.874012695	1	< 0.1%

AC 6
Real number (ℝ_≥0)

ZEROS

Distinct	29151
Distinct (%)	84.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.709061098

Minimum	0
Maximum	9.929291016
Zeros	5455
Zeros (%)	15.7%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.877316162
median	2.819161865
Q3	3.742867737
95-th percentile	5.195097388
Maximum	9.929291016
Range	9.929291016
Interquartile range (IQR)	1.865551575

Descriptive statistics

Standard deviation	1.590249042
Coefficient of variation (CV)	0.5870111396
Kurtosis	-0.2300756941
Mean	2.709061098
Median Absolute Deviation (MAD)	0.9327965088
Skewness	-0.1068010393
Sum	93847.29455
Variance	2.528892016
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5455	15.7%
5.107904297	2	< 0.1%
3.849658447	2	< 0.1%
1.767871582	2	< 0.1%
5.927287598	2	< 0.1%
4.623115723	2	< 0.1%
2.63522876	2	< 0.1%
3.60592334	2	< 0.1%
3.445003662	2	< 0.1%
3.669658936	2	< 0.1%
Other values (29141)	29169	84.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5455	15.7%
0.06465927887	1	< 0.1%
0.09148364258	1	< 0.1%
0.09236633301	1	< 0.1%
0.09339237213	1	< 0.1%
0.09700898743	1	< 0.1%
0.09711601257	1	< 0.1%
0.0983099823	1	< 0.1%
0.09832727814	1	< 0.1%
0.100603981	1	< 0.1%

Value	Count	Frequency (%)
9.929291016	1	< 0.1%
9.666423828	1	< 0.1%
9.227158203	1	< 0.1%
8.944285156	1	< 0.1%
8.818060547	1	< 0.1%
8.784804687	1	< 0.1%
8.595863281	1	< 0.1%
8.365535156	1	< 0.1%
8.330058594	1	< 0.1%
8.324936523	1	< 0.1%

AC 7
Real number (ℝ_≥0)

ZEROS

Distinct	31255
Distinct (%)	90.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.945135605

Minimum	0
Maximum	9.356776367
Zeros	3355
Zeros (%)	9.7%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.161930786
median	2.976191284
Q3	3.852767273
95-th percentile	5.347440649
Maximum	9.356776367
Range	9.356776367
Interquartile range (IQR)	1.690836487

Descriptive statistics

Standard deviation	1.487934048
Coefficient of variation (CV)	0.5052175001
Kurtosis	0.4155042966
Mean	2.945135605
Median Absolute Deviation (MAD)	0.8436320801
Skewness	-0.04822787553
Sum	102025.3876
Variance	2.213947731
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3355	9.7%
3.14246582	2	< 0.1%
2.527106445	2	< 0.1%
4.276289551	2	< 0.1%
4.237095703	2	< 0.1%
3.240780273	2	< 0.1%
3.496192871	2	< 0.1%
3.043163086	2	< 0.1%
2.649957031	2	< 0.1%
2.815222656	2	< 0.1%
Other values (31245)	31269	90.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3355	9.7%
0.05282098389	1	< 0.1%
0.05658594131	1	< 0.1%
0.05895381165	1	< 0.1%
0.06176008987	1	< 0.1%
0.06493132782	1	< 0.1%
0.06606751251	1	< 0.1%
0.06822737122	1	< 0.1%
0.06858148193	1	< 0.1%
0.0746751709	1	< 0.1%

Value	Count	Frequency (%)
9.356776367	1	< 0.1%
9.259009766	1	< 0.1%
9.251232422	1	< 0.1%
9.202111328	1	< 0.1%
9.200707031	1	< 0.1%
9.153392578	1	< 0.1%
9.146301758	1	< 0.1%
9.112842773	1	< 0.1%
9.107796875	1	< 0.1%
9.07315332	1	< 0.1%

AC 8
Real number (ℝ_≥0)

ZEROS

Distinct	29269
Distinct (%)	84.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.568989438

Minimum	0
Maximum	9.331505859
Zeros	5331
Zeros (%)	15.4%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.766606171
median	2.62213562
Q3	3.538364075
95-th percentile	5.037801733
Maximum	9.331505859
Range	9.331505859
Interquartile range (IQR)	1.771757904

Descriptive statistics

Standard deviation	1.531968043
Coefficient of variation (CV)	0.5963310009
Kurtosis	-0.09593831258
Mean	2.568989438
Median Absolute Deviation (MAD)	0.885206543
Skewness	0.008589821761
Sum	88994.93213
Variance	2.346926085
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5331	15.4%
3.324664551	2	< 0.1%
2.706187256	2	< 0.1%
3.133732178	2	< 0.1%
2.652265381	2	< 0.1%
2.109123779	2	< 0.1%
2.450452637	2	< 0.1%
3.139876953	2	< 0.1%
2.562466309	2	< 0.1%
3.045667969	2	< 0.1%
Other values (29259)	29293	84.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5331	15.4%
0.01094765377	1	< 0.1%
0.04681337357	1	< 0.1%
0.05472441101	1	< 0.1%
0.06058576202	1	< 0.1%
0.06112965775	1	< 0.1%
0.06130023956	1	< 0.1%
0.06155838394	1	< 0.1%
0.06180289078	1	< 0.1%
0.06196854401	1	< 0.1%

Value	Count	Frequency (%)
9.331505859	1	< 0.1%
9.224646484	1	< 0.1%
9.12290332	1	< 0.1%
9.043263672	1	< 0.1%
9.030961914	1	< 0.1%
9.0003125	1	< 0.1%
8.881724609	1	< 0.1%
8.76128418	1	< 0.1%
8.636970703	1	< 0.1%
8.613015625	1	< 0.1%

AC 9
Real number (ℝ_≥0)

ZEROS

Distinct	32241
Distinct (%)	93.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.149919277

Minimum	0
Maximum	10.02674707
Zeros	2367
Zeros (%)	6.8%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.273552063
median	3.046701538
Q3	4.046423828
95-th percentile	5.824332959
Maximum	10.02674707
Range	10.02674707
Interquartile range (IQR)	1.772871765

Descriptive statistics

Standard deviation	1.534837638
Coefficient of variation (CV)	0.4872625304
Kurtosis	0.8566130427
Mean	3.149919277
Median Absolute Deviation (MAD)	0.8699578857
Skewness	0.2796879564
Sum	109119.5036
Variance	2.355726575
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2367	6.8%
2.178085938	2	< 0.1%
3.086960693	2	< 0.1%
2.606552002	2	< 0.1%
3.055231201	2	< 0.1%
3.597266357	2	< 0.1%
4.305642578	2	< 0.1%
4.764799805	2	< 0.1%
3.708388428	2	< 0.1%
3.05663208	2	< 0.1%
Other values (32231)	32257	93.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2367	6.8%
0.08138726044	1	< 0.1%
0.08161660767	1	< 0.1%
0.0887253418	1	< 0.1%
0.08977192688	1	< 0.1%
0.1052763138	1	< 0.1%
0.107641304	1	< 0.1%
0.1096568604	1	< 0.1%
0.1099549484	1	< 0.1%
0.1100972519	1	< 0.1%

Value	Count	Frequency (%)
10.02674707	1	< 0.1%
9.798385742	1	< 0.1%
9.749407227	1	< 0.1%
9.667248047	1	< 0.1%
9.607086914	1	< 0.1%
9.595224609	1	< 0.1%
9.56228125	1	< 0.1%
9.537615234	1	< 0.1%
9.524496094	1	< 0.1%
9.523412109	1	< 0.1%

AC 10
Real number (ℝ_≥0)

ZEROS

Distinct	32711
Distinct (%)	94.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.539393139

Minimum	0
Maximum	4.625029785
Zeros	1903
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.106887299
median	1.500257202
Q3	1.97783606
95-th percentile	2.742939941
Maximum	4.625029785
Range	4.625029785
Interquartile range (IQR)	0.870948761

Descriptive statistics

Standard deviation	0.7003723441
Coefficient of variation (CV)	0.4549665229
Kurtosis	0.4261369435
Mean	1.539393139
Median Absolute Deviation (MAD)	0.4287334595
Skewness	0.1226602453
Sum	53327.65714
Variance	0.4905214204
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1903	5.5%
1.829689819	2	< 0.1%
2.115071289	2	< 0.1%
1.197075195	2	< 0.1%
0.6590256348	2	< 0.1%
1.560997437	2	< 0.1%
1.264098267	2	< 0.1%
1.040553223	2	< 0.1%
1.98887439	2	< 0.1%
0.9309008179	2	< 0.1%
Other values (32701)	32721	94.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1903	5.5%
0.07110451508	1	< 0.1%
0.07147119904	1	< 0.1%
0.07976487732	1	< 0.1%
0.08359114838	1	< 0.1%
0.100279953	1	< 0.1%
0.1003293457	1	< 0.1%
0.1011818008	1	< 0.1%
0.1034925995	1	< 0.1%
0.1034997025	1	< 0.1%

Value	Count	Frequency (%)
4.625029785	1	< 0.1%
4.561019531	1	< 0.1%
4.498272461	1	< 0.1%
4.429328125	1	< 0.1%
4.428435547	1	< 0.1%
4.3871875	1	< 0.1%
4.355806152	1	< 0.1%
4.321361328	1	< 0.1%
4.259918457	1	< 0.1%
4.248070801	1	< 0.1%

AC 11
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	29342
Distinct (%)	84.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.486161853

Minimum	0
Maximum	10.36315137
Zeros	5270
Zeros (%)	15.2%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.640117249
median	2.409043335
Q3	3.36275293
95-th percentile	5.170304077
Maximum	10.36315137
Range	10.36315137
Interquartile range (IQR)	1.722635681

Descriptive statistics

Standard deviation	1.588902335
Coefficient of variation (CV)	0.6390985097
Kurtosis	1.075884584
Mean	2.486161853
Median Absolute Deviation (MAD)	0.856703125
Skewness	0.5189782705
Sum	86125.6189
Variance	2.52461063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5270	15.2%
3.004993408	2	< 0.1%
4.154209473	2	< 0.1%
3.315104492	2	< 0.1%
2.410487549	2	< 0.1%
1.059351563	2	< 0.1%
3.834279785	2	< 0.1%
2.321346924	2	< 0.1%
1.903718018	2	< 0.1%
4.957069336	2	< 0.1%
Other values (29332)	29354	84.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5270	15.2%
0.07264399719	1	< 0.1%
0.07793022919	1	< 0.1%
0.09986977386	1	< 0.1%
0.1012279358	1	< 0.1%
0.1023413467	1	< 0.1%
0.1035502548	1	< 0.1%
0.1037963257	1	< 0.1%
0.1051286697	1	< 0.1%
0.1053280411	1	< 0.1%

Value	Count	Frequency (%)
10.36315137	1	< 0.1%
10.34442676	1	< 0.1%
10.09486426	1	< 0.1%
9.982568359	1	< 0.1%
9.886742187	1	< 0.1%
9.877746094	1	< 0.1%
9.876814453	1	< 0.1%
9.870907227	1	< 0.1%
9.867012695	1	< 0.1%
9.835919922	1	< 0.1%

AC 12
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	31444
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.815970359

Minimum	0
Maximum	9.887305664
Zeros	3163
Zeros (%)	9.1%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.066214294
median	2.824785889
Q3	3.660598999
95-th percentile	5.017686597
Maximum	9.887305664
Range	9.887305664
Interquartile range (IQR)	1.594384705

Descriptive statistics

Standard deviation	1.402621897
Coefficient of variation (CV)	0.4980954053
Kurtosis	0.8118488801
Mean	2.815970359
Median Absolute Deviation (MAD)	0.7939100342
Skewness	0.04718841721
Sum	97550.84518
Variance	1.967348187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3163	9.1%
2.786959473	2	< 0.1%
2.832355225	2	< 0.1%
3.165344482	2	< 0.1%
3.706915771	2	< 0.1%
2.601605957	2	< 0.1%
3.920286865	2	< 0.1%
2.696984131	2	< 0.1%
4.693541992	2	< 0.1%
2.814131592	2	< 0.1%
Other values (31434)	31461	90.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3163	9.1%
0.04597567749	1	< 0.1%
0.06100495911	1	< 0.1%
0.06218890381	1	< 0.1%
0.06372197723	1	< 0.1%
0.06406093597	1	< 0.1%
0.06573043823	1	< 0.1%
0.06598792267	1	< 0.1%
0.06802828217	1	< 0.1%
0.07106945038	1	< 0.1%

Value	Count	Frequency (%)
9.887305664	1	< 0.1%
9.708526367	1	< 0.1%
9.660108398	1	< 0.1%
9.632356445	1	< 0.1%
9.576805664	1	< 0.1%
9.573359375	1	< 0.1%
9.567575195	1	< 0.1%
9.561782227	1	< 0.1%
9.531632812	1	< 0.1%
9.511005859	1	< 0.1%

AC 13
Real number (ℝ_≥0)

ZEROS

Distinct	32744
Distinct (%)	94.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.313003707

Minimum	0
Maximum	9.796392578
Zeros	1852
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.27309198
median	4.239078125
Q3	5.433044312
95-th percentile	7.575033521
Maximum	9.796392578
Range	9.796392578
Interquartile range (IQR)	2.159952332

Descriptive statistics

Standard deviation	1.872006842
Coefficient of variation (CV)	0.4340378468
Kurtosis	0.4179649143
Mean	4.313003707
Median Absolute Deviation (MAD)	1.06927124
Skewness	-0.05291426274
Sum	149411.0744
Variance	3.504409617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1852	5.3%
5.592882324	2	< 0.1%
5.296687988	2	< 0.1%
3.471577637	2	< 0.1%
4.941166016	2	< 0.1%
2.749988281	2	< 0.1%
4.451264648	2	< 0.1%
5.77767334	2	< 0.1%
4.334330078	2	< 0.1%
3.415598633	2	< 0.1%
Other values (32734)	32772	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1852	5.3%
0.05376508331	1	< 0.1%
0.07805438232	1	< 0.1%
0.08096426392	1	< 0.1%
0.09130158997	1	< 0.1%
0.09224546051	1	< 0.1%
0.09587715149	1	< 0.1%
0.09827393341	1	< 0.1%
0.1156708603	1	< 0.1%
0.1662820892	1	< 0.1%

Value	Count	Frequency (%)
9.796392578	1	< 0.1%
9.772299805	1	< 0.1%
9.752236328	1	< 0.1%
9.704908203	1	< 0.1%
9.693636719	1	< 0.1%
9.688960937	1	< 0.1%
9.687146484	1	< 0.1%
9.681642578	1	< 0.1%
9.631702148	1	< 0.1%
9.630237305	1	< 0.1%

AC 14
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	33190
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.957059635

Minimum	0
Maximum	9.05496875
Zeros	1423
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1.065869006
Q1	1.85509314
median	2.79464502
Q3	3.892645813
95-th percentile	5.677727734
Maximum	9.05496875
Range	9.05496875
Interquartile range (IQR)	2.037552673

Descriptive statistics

Standard deviation	1.505042947
Coefficient of variation (CV)	0.5089660448
Kurtosis	0.2735678254
Mean	2.957059635
Median Absolute Deviation (MAD)	1.006006348
Skewness	0.4968710777
Sum	102438.4599
Variance	2.265154271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1423	4.1%
3.293982178	2	< 0.1%
4.298284668	2	< 0.1%
2.646483643	2	< 0.1%
3.242646973	2	< 0.1%
3.72209668	2	< 0.1%
2.280685059	2	< 0.1%
4.148039062	2	< 0.1%
4.998311523	2	< 0.1%
3.461662842	2	< 0.1%
Other values (33180)	33201	95.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1423	4.1%
0.05777108002	1	< 0.1%
0.09741861725	1	< 0.1%
0.1004549103	1	< 0.1%
0.1027828751	1	< 0.1%
0.2021311493	1	< 0.1%
0.2034016724	1	< 0.1%
0.206105011	1	< 0.1%
0.2383424683	1	< 0.1%
0.2558401642	1	< 0.1%

Value	Count	Frequency (%)
9.05496875	1	< 0.1%
9.051729492	1	< 0.1%
9.020098633	1	< 0.1%
8.966863281	1	< 0.1%
8.965724609	1	< 0.1%
8.935588867	1	< 0.1%
8.925925781	1	< 0.1%
8.923538086	1	< 0.1%
8.916717773	1	< 0.1%
8.907552734	1	< 0.1%

AC 15
Real number (ℝ_≥0)

ZEROS

Distinct	31602
Distinct (%)	91.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.124136391

Minimum	0
Maximum	10.34999805
Zeros	2994
Zeros (%)	8.6%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.025755554
median	4.092966309
Q3	5.409612915
95-th percentile	7.428825659
Maximum	10.34999805
Range	10.34999805
Interquartile range (IQR)	2.383857361

Descriptive statistics

Standard deviation	2.003805326
Coefficient of variation (CV)	0.4858727104
Kurtosis	0.1152899216
Mean	4.124136391
Median Absolute Deviation (MAD)	1.162825073
Skewness	-0.1276483446
Sum	142868.3329
Variance	4.015235785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2994	8.6%
5.301657227	2	< 0.1%
3.16152002	2	< 0.1%
3.731053711	2	< 0.1%
6.40251416	2	< 0.1%
3.392231689	2	< 0.1%
5.52630957	2	< 0.1%
4.406300781	2	< 0.1%
3.318557129	2	< 0.1%
5.344153809	2	< 0.1%
Other values (31592)	31630	91.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2994	8.6%
0.05994290543	1	< 0.1%
0.06184532928	1	< 0.1%
0.06190799713	1	< 0.1%
0.06432749176	1	< 0.1%
0.06555576324	1	< 0.1%
0.06661433411	1	< 0.1%
0.06703911591	1	< 0.1%
0.06762007904	1	< 0.1%
0.0688780899	1	< 0.1%

Value	Count	Frequency (%)
10.34999805	1	< 0.1%
10.34407812	1	< 0.1%
10.27858984	1	< 0.1%
10.255	1	< 0.1%
10.23435547	1	< 0.1%
10.23135059	1	< 0.1%
10.22962793	1	< 0.1%
10.22626465	1	< 0.1%
10.21599316	1	< 0.1%
10.19888574	1	< 0.1%

AC 16
Real number (ℝ_≥0)

ZEROS

Distinct	30952
Distinct (%)	89.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.765702736

Minimum	0
Maximum	9.789501953
Zeros	3661
Zeros (%)	10.6%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.867401245
median	2.685934082
Q3	3.701203064
95-th percentile	5.471938501
Maximum	9.789501953
Range	9.789501953
Interquartile range (IQR)	1.833801819

Descriptive statistics

Standard deviation	1.538245296
Coefficient of variation (CV)	0.5561860557
Kurtosis	0.1504121083
Mean	2.765702736
Median Absolute Deviation (MAD)	0.9068327026
Skewness	0.2029748109
Sum	95809.47417
Variance	2.36619859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3661	10.6%
2.772634033	2	< 0.1%
2.281194824	2	< 0.1%
2.829662354	2	< 0.1%
4.096311035	2	< 0.1%
4.177881836	2	< 0.1%
2.742169189	2	< 0.1%
2.759802734	2	< 0.1%
3.449891846	2	< 0.1%
1.747108032	2	< 0.1%
Other values (30942)	30963	89.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3661	10.6%
0.04327206802	1	< 0.1%
0.05373293304	1	< 0.1%
0.05482838821	1	< 0.1%
0.06091388702	1	< 0.1%
0.06123699951	1	< 0.1%
0.06150212479	1	< 0.1%
0.06163067245	1	< 0.1%
0.06341194916	1	< 0.1%
0.07005699921	1	< 0.1%

Value	Count	Frequency (%)
9.789501953	1	< 0.1%
9.252208008	1	< 0.1%
9.14399707	1	< 0.1%
9.011677734	1	< 0.1%
8.835966797	1	< 0.1%
8.770001953	1	< 0.1%
8.691416016	1	< 0.1%
8.661050781	1	< 0.1%
8.598038086	1	< 0.1%
8.580469727	1	< 0.1%

AC 17
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	33923
Distinct (%)	97.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.255119185

Minimum	0
Maximum	5.950260742
Zeros	583
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2.298912415
Q1	3.773064819
median	4.624716309
Q3	4.97774353
95-th percentile	5.340350879
Maximum	5.950260742
Range	5.950260742
Interquartile range (IQR)	1.204678711

Descriptive statistics

Standard deviation	1.078238006
Coefficient of variation (CV)	0.253397839
Kurtosis	2.970498944
Mean	4.255119185
Median Absolute Deviation (MAD)	0.4464968262
Skewness	-1.640191977
Sum	147405.8388
Variance	1.162597198
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	583	1.7%
4.606140137	3	< 0.1%
5.466534668	3	< 0.1%
4.490296875	2	< 0.1%
4.952848633	2	< 0.1%
4.369889648	2	< 0.1%
5.128876465	2	< 0.1%
4.894649902	2	< 0.1%
5.129799316	2	< 0.1%
4.534805176	2	< 0.1%
Other values (33913)	34039	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	583	1.7%
0.1014455566	1	< 0.1%
0.1230265045	1	< 0.1%
0.1231611099	1	< 0.1%
0.1247366791	1	< 0.1%
0.1315752258	1	< 0.1%
0.1416380005	1	< 0.1%
0.1680333862	1	< 0.1%
0.1932807007	1	< 0.1%
0.2625445862	1	< 0.1%

Value	Count	Frequency (%)
5.950260742	1	< 0.1%
5.945301758	1	< 0.1%
5.863141602	1	< 0.1%
5.83578125	1	< 0.1%
5.830320312	1	< 0.1%
5.820865234	1	< 0.1%
5.81526123	1	< 0.1%
5.802086914	1	< 0.1%
5.798219238	1	< 0.1%
5.795905762	1	< 0.1%

AC 18
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	33737
Distinct (%)	97.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.453815486

Minimum	0
Maximum	11.04003125
Zeros	837
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	270.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3.461707507
Q1	4.00686853
median	7.072845947
Q3	8.25281543
95-th percentile	9.293142529
Maximum	11.04003125
Range	11.04003125
Interquartile range (IQR)	4.245946899

Descriptive statistics

Standard deviation	2.249975206
Coefficient of variation (CV)	0.3486271355
Kurtosis	-0.251521506
Mean	6.453815486
Median Absolute Deviation (MAD)	1.552670654
Skewness	-0.6645544155
Sum	223573.0761
Variance	5.062388427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	837	2.4%
9.08178418	2	< 0.1%
7.860595215	2	< 0.1%
8.340766602	2	< 0.1%
8.785417969	2	< 0.1%
9.214401367	2	< 0.1%
8.353989258	2	< 0.1%
9.533463867	2	< 0.1%
9.071806641	2	< 0.1%
8.405483398	2	< 0.1%
Other values (33727)	33787	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	837	2.4%
0.209085968	1	< 0.1%
0.2099752655	1	< 0.1%
0.2230535889	1	< 0.1%
0.2295393829	1	< 0.1%
0.2396819	1	< 0.1%
0.2518437042	1	< 0.1%
0.3175652466	1	< 0.1%
0.3961244507	1	< 0.1%
0.4883180847	1	< 0.1%

Value	Count	Frequency (%)
11.04003125	1	< 0.1%
10.71482617	1	< 0.1%
10.37858301	1	< 0.1%
10.35876563	1	< 0.1%
10.32136426	1	< 0.1%
10.31974121	1	< 0.1%
10.29013281	1	< 0.1%
10.27546387	1	< 0.1%
10.2563418	1	< 0.1%
10.25142578	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	Date & Time	AC 1	AC 2	AC 3	AC 4	AC 5	AC 6	AC 7	AC 8	AC 9	AC 10	AC 11	AC 12	AC 13	AC 14	AC 15	AC 16	AC 17	AC 18
0	0	2019-08-01 00:00:00	7.518632	8.788315	0.000000	0.000000	2.617045	4.079041	2.782276	4.624447	5.222060	2.151238	1.585072	0.560373	3.142941	2.749470	5.417774	4.113460	3.305072	6.735981
1	2	2019-08-01 00:02:00	7.426114	8.940615	0.000000	0.000000	2.581625	3.781231	2.529366	5.057423	5.349465	2.414715	2.168184	1.818730	3.085110	2.720484	3.302422	3.986483	3.220588	6.379500
2	4	2019-08-01 00:04:00	7.052986	9.161103	0.000000	0.000000	2.592095	3.800127	2.332304	6.322521	3.995392	2.237114	3.345624	2.310409	3.132799	2.676861	3.539026	3.797881	3.131560	6.363475
3	6	2019-08-01 00:06:00	6.665446	9.065626	0.000000	0.000000	2.575639	3.772891	2.596200	5.805132	3.553778	1.878356	2.737645	2.510972	3.090007	2.666604	4.607439	3.062610	3.063953	6.127366
4	8	2019-08-01 00:08:00	6.674838	9.096130	0.000000	0.000000	2.021472	3.155697	2.845417	6.315060	3.042244	1.914650	2.452500	2.171791	3.097202	2.710572	5.332696	2.640150	2.864680	5.662474
5	10	2019-08-01 00:10:00	6.567156	9.037213	1.473477	0.284310	1.993010	3.910083	2.493377	5.169652	3.125476	1.900643	2.398804	2.503357	3.114851	2.774171	6.068003	2.497199	3.063759	5.805874
6	12	2019-08-01 00:12:00	6.453244	9.044919	1.829450	1.682536	1.887994	3.290534	2.384930	4.976252	3.097164	1.908729	2.302548	2.572876	3.102615	2.776231	6.450241	3.079120	3.089316	6.246021
7	14	2019-08-01 00:14:00	6.465478	9.090386	1.855697	2.259675	1.810324	3.510855	2.965181	4.956650	3.124932	2.183731	1.906641	2.391689	4.289458	3.495441	6.365123	3.017883	3.140137	6.273877
8	18	2019-08-01 00:18:00	6.368224	8.158823	2.839488	2.301862	2.811552	3.514442	3.300419	4.392541	3.096956	3.505346	1.885703	2.226469	4.367508	5.122032	6.328834	3.366155	3.501677	6.745517
9	20	2019-08-01 00:20:00	6.518812	7.962736	2.736410	1.887470	2.580264	3.852544	3.226622	4.614456	3.066071	3.430041	1.799723	2.431497	4.023512	5.179115	6.204670	3.280784	3.549387	7.077375

Last rows

	df_index	Date & Time	AC 1	AC 2	AC 3	AC 4	AC 5	AC 6	AC 7	AC 8	AC 9	AC 10	AC 11	AC 12	AC 13	AC 14	AC 15	AC 16	AC 17	AC 18
34632	87821	2019-09-30 23:41:00	2.894448	8.152282	4.154071	2.358552	1.157666	0.000000	3.032432	4.631509	4.894442	1.651598	5.041930	4.156700	4.419645	2.425940	3.670222	1.554395	3.450773	3.641647
34633	87823	2019-09-30 23:43:00	3.467300	8.335151	3.280842	2.104241	0.987955	0.000000	4.179667	3.595802	4.545187	1.463642	5.623581	4.516745	5.037816	2.304115	3.661031	1.597521	3.461860	3.650063
34634	87825	2019-09-30 23:45:00	2.883133	8.573294	2.976298	2.063815	0.000000	0.000000	4.614667	4.755458	4.201666	1.368366	6.108105	4.296801	5.008359	2.742367	3.704892	1.556722	2.675439	5.850771
34635	87827	2019-09-30 23:47:00	2.807148	8.482985	2.357741	1.764776	0.000000	0.000000	4.182721	4.997620	3.576860	1.378745	4.695837	3.892353	4.766902	2.973909	3.693686	1.578630	3.043333	7.149420
34636	87829	2019-09-30 23:49:00	0.000000	6.657014	2.418670	1.531352	0.000000	0.000000	4.014735	4.820883	3.558004	2.819254	4.595729	3.531902	5.267506	2.840872	3.719538	1.503313	3.032459	7.171342
34637	87831	2019-09-30 23:51:00	0.000000	6.089533	2.322677	1.422932	0.000000	0.000000	3.729901	3.747301	3.578350	1.714157	5.146438	3.253012	2.464426	2.829701	3.693877	1.992432	3.029462	7.202612
34638	87833	2019-09-30 23:53:00	0.000000	6.046765	2.195754	1.861175	0.813454	0.000000	3.666080	3.017628	3.600397	1.547953	4.379771	3.144666	3.045807	2.693068	4.090679	1.944854	3.048858	7.348333
34639	87835	2019-09-30 23:55:00	0.000000	6.122385	2.192198	2.083315	1.046250	0.000000	3.668421	3.006311	3.614301	1.860847	5.019769	3.154221	3.648026	2.439526	4.062719	1.854352	3.027539	7.259989
34640	87837	2019-09-30 23:57:00	1.209176	6.152532	2.211421	0.000000	1.448103	0.000000	3.151248	2.871690	3.417942	2.185493	5.174168	2.772349	3.786657	2.060023	4.057525	1.870886	2.991946	7.134647
34641	87839	2019-09-30 23:59:00	1.430442	6.078281	1.891162	0.000000	1.577491	4.364239	3.126339	3.287224	3.986978	2.013912	4.821829	3.363855	3.380110	1.949240	4.026304	1.862166	3.009434	7.179719

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows